import pandas as pd
# 读取中信银行信用卡已出账流水
def ZX_credit_posted_tolist(file) :
    df_list = pd.read_excel(file).values.tolist()[1:]
    df_list = [[str(col).strip() for col in row] for row in df_list]
    txt_list=[]
    for row in df_list:
        row = [f"{row[1][:4]}-{row[1][4:6]}-{row[1][6:]}",row[3],row[-1]]
        txt_list.append(row)
    return txt_list